Olist Profiling Report

Dataset statistics

Number of variables	39
Number of observations	118315
Missing cells	182649
Missing cells (%)	4.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	208.8 MiB
Average record size in memory	1.8 KiB

Variable types

Categorical	24
Numeric	15

Warnings

`order_id` has a high cardinality: 98665 distinct values	High cardinality
`product_id` has a high cardinality: 32951 distinct values	High cardinality
`seller_id` has a high cardinality: 3095 distinct values	High cardinality
`shipping_limit_date` has a high cardinality: 93317 distinct values	High cardinality
`product_category_name` has a high cardinality: 73 distinct values	High cardinality
`seller_city` has a high cardinality: 611 distinct values	High cardinality
`review_id` has a high cardinality: 98452 distinct values	High cardinality
`review_comment_title` has a high cardinality: 4569 distinct values	High cardinality
`review_comment_message` has a high cardinality: 36434 distinct values	High cardinality
`review_creation_date` has a high cardinality: 633 distinct values	High cardinality
`review_answer_timestamp` has a high cardinality: 98290 distinct values	High cardinality
`customer_id` has a high cardinality: 98665 distinct values	High cardinality
`order_purchase_timestamp` has a high cardinality: 98111 distinct values	High cardinality
`order_approved_at` has a high cardinality: 90173 distinct values	High cardinality
`order_delivered_carrier_date` has a high cardinality: 81016 distinct values	High cardinality
`order_delivered_customer_date` has a high cardinality: 95663 distinct values	High cardinality
`order_estimated_delivery_date` has a high cardinality: 449 distinct values	High cardinality
`customer_unique_id` has a high cardinality: 95419 distinct values	High cardinality
`customer_city` has a high cardinality: 4110 distinct values	High cardinality
`price` is highly correlated with `payment_value`	High correlation
`freight_value` is highly correlated with `product_weight_g`	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_weight_g` is highly correlated with `freight_value` and 2 other fields	High correlation
`product_length_cm` is highly correlated with `product_width_cm`	High correlation
`product_height_cm` is highly correlated with `product_weight_g`	High correlation
`product_width_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`price` is highly correlated with `payment_value` and 1 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_weight_g` is highly correlated with `price` and 3 other fields	High correlation
`product_length_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`product_height_cm` is highly correlated with `product_weight_g`	High correlation
`product_width_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`order_item_id` is highly correlated with `payment_sequential`	High correlation
`price` is highly correlated with `payment_sequential` and 1 other fields	High correlation
`freight_value` is highly correlated with `payment_sequential`	High correlation
`payment_sequential` is highly correlated with `order_item_id` and 2 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_height_cm` is highly correlated with `product_category_name`	High correlation
`product_description_lenght` is highly correlated with `product_category_name`	High correlation
`price` is highly correlated with `payment_value`	High correlation
`customer_state` is highly correlated with `customer_zip_code_prefix`	High correlation
`product_length_cm` is highly correlated with `product_width_cm` and 1 other fields	High correlation
`product_weight_g` is highly correlated with `product_category_name`	High correlation
`product_width_cm` is highly correlated with `product_length_cm` and 1 other fields	High correlation
`seller_state` is highly correlated with `seller_zip_code_prefix` and 1 other fields	High correlation
`customer_zip_code_prefix` is highly correlated with `customer_state`	High correlation
`seller_zip_code_prefix` is highly correlated with `seller_state` and 1 other fields	High correlation
`product_category_name` is highly correlated with `product_height_cm` and 6 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_category_name` has 1709 (1.4%) missing values	Missing
`product_name_lenght` has 1709 (1.4%) missing values	Missing
`product_description_lenght` has 1709 (1.4%) missing values	Missing
`product_photos_qty` has 1709 (1.4%) missing values	Missing
`review_comment_title` has 104226 (88.1%) missing values	Missing
`review_comment_message` has 67650 (57.2%) missing values	Missing
`order_delivered_carrier_date` has 1254 (1.1%) missing values	Missing
`order_delivered_customer_date` has 2588 (2.2%) missing values	Missing
`order_id` is uniformly distributed	Uniform
`shipping_limit_date` is uniformly distributed	Uniform
`review_id` is uniformly distributed	Uniform
`review_answer_timestamp` is uniformly distributed	Uniform
`customer_id` is uniformly distributed	Uniform
`order_purchase_timestamp` is uniformly distributed	Uniform
`order_approved_at` is uniformly distributed	Uniform
`order_delivered_customer_date` is uniformly distributed	Uniform
`customer_unique_id` is uniformly distributed	Uniform

Reproduction

Analysis started	2021-08-09 19:56:27.245288
Analysis finished	2021-08-09 21:15:56.937797
Duration	1 hour, 19 minutes and 29.69 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

order_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98665
Distinct (%)	83.4%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

895ab968e7bb0d5659d16cd74cd1650c	63
fedcd9f7ccdc8cba3a18defedd1a5547	38
fa65dad1b0e818e3ccc5cb0e39231352	29
ccf804e764ed5650cd8759557269dc13	26
6d58638e32674bebee793a47ac4cbadc	24
Other values (98660)	118135

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85739 ?
Unique (%)	72.5%

Sample

1st row	00010242fe8c5a6d1ba2dd792cb16214
2nd row	130898c0987d1801452a8ed92a670612
3rd row	532ed5e14e24ae1f0d735b91524b98b9
4th row	6f8c31653edb8c83e1a739408b5ff750
5th row	7d19f4ef4d04461989632411b7e588b9

Common Values

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (98655)	118017	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (98655)	118017	99.7%

Most occurring characters

Value	Count	Frequency (%)
4	237711	6.3%
6	237574	6.3%
b	237565	6.3%
e	237315	6.3%
3	236962	6.3%
c	236920	6.3%
7	236861	6.3%
8	236857	6.3%
1	236825	6.3%
a	236543	6.2%
Other values (6)	1414947	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2365838	62.5%
Lowercase Letter	1420242	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	237711	10.0%
6	237574	10.0%
3	236962	10.0%
7	236861	10.0%
8	236857	10.0%
1	236825	10.0%
2	236349	10.0%
9	236003	10.0%
0	235394	9.9%
5	235302	9.9%

Lowercase Letter

Value	Count	Frequency (%)
b	237565	16.7%
e	237315	16.7%
c	236920	16.7%
a	236543	16.7%
f	236195	16.6%
d	235704	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2365838	62.5%
Latin	1420242	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	237711	10.0%
6	237574	10.0%
3	236962	10.0%
7	236861	10.0%
8	236857	10.0%
1	236825	10.0%
2	236349	10.0%
9	236003	10.0%
0	235394	9.9%
5	235302	9.9%

Latin

Value	Count	Frequency (%)
b	237565	16.7%
e	237315	16.7%
c	236920	16.7%
a	236543	16.7%
f	236195	16.6%
d	235704	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	237711	6.3%
6	237574	6.3%
b	237565	6.3%
e	237315	6.3%
3	236962	6.3%
c	236920	6.3%
7	236861	6.3%
8	236857	6.3%
1	236825	6.3%
a	236543	6.2%
Other values (6)	1414947	37.4%

order_item_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.196509318

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6994522013
Coefficient of variation (CV)	0.5845773122
Kurtosis	103.373708
Mean	1.196509318
Median Absolute Deviation (MAD)	0
Skewness	7.552581474
Sum	141565
Variance	0.4892333819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	103652	87.6%
2	10316	8.7%
3	2395	2.0%
4	995	0.8%
5	472	0.4%
6	265	0.2%
7	61	0.1%
8	37	< 0.1%
9	29	< 0.1%
10	26	< 0.1%
Other values (11)	67	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	103652	87.6%
2	10316	8.7%
3	2395	2.0%
4	995	0.8%
5	472	0.4%
6	265	0.2%
7	61	0.1%
8	37	< 0.1%
9	29	< 0.1%
10	26	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%
16	3	< 0.1%
15	5	< 0.1%
14	7	< 0.1%
13	8	< 0.1%
12	13	< 0.1%

product_id
Categorical

HIGH CARDINALITY

Distinct	32951
Distinct (%)	27.9%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

aca2eb7d00ea1a7b8ebd4e68314663af	536
99a4788cb24856965c36a24e339b6058	528
422879e10f46682990de24d770e7f83d	508
389d119b48cf3043d311335e499d9c6b	406
368c6c730842d78016ad823897a372db	398
Other values (32946)	115939

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17344 ?
Unique (%)	14.7%

Sample

1st row	4244733e06e7ecb4970a6e2683c13e61
2nd row	4244733e06e7ecb4970a6e2683c13e61
3rd row	4244733e06e7ecb4970a6e2683c13e61
4th row	4244733e06e7ecb4970a6e2683c13e61
5th row	4244733e06e7ecb4970a6e2683c13e61

Common Values

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	536	0.5%
99a4788cb24856965c36a24e339b6058	528	0.4%
422879e10f46682990de24d770e7f83d	508	0.4%
389d119b48cf3043d311335e499d9c6b	406	0.3%
368c6c730842d78016ad823897a372db	398	0.3%
53759a2ecddad2bb87a079a1f1519f73	391	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	357	0.3%
53b36df67ebb7c41585e8d54d6772e08	327	0.3%
154e7e31ebfa092203795c972e5804a6	295	0.2%
3dd2a17168ec895c781a9191c1e95ad7	278	0.2%
Other values (32941)	114291	96.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	536	0.5%
99a4788cb24856965c36a24e339b6058	528	0.4%
422879e10f46682990de24d770e7f83d	508	0.4%
389d119b48cf3043d311335e499d9c6b	406	0.3%
368c6c730842d78016ad823897a372db	398	0.3%
53759a2ecddad2bb87a079a1f1519f73	391	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	357	0.3%
53b36df67ebb7c41585e8d54d6772e08	327	0.3%
154e7e31ebfa092203795c972e5804a6	295	0.2%
3dd2a17168ec895c781a9191c1e95ad7	278	0.2%
Other values (32941)	114291	96.6%

Most occurring characters

Value	Count	Frequency (%)
3	243136	6.4%
9	241101	6.4%
e	238901	6.3%
8	238256	6.3%
7	238171	6.3%
4	237494	6.3%
a	237300	6.3%
c	236404	6.2%
0	236283	6.2%
2	236127	6.2%
Other values (6)	1402907	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2375922	62.8%
Lowercase Letter	1410158	37.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	243136	10.2%
9	241101	10.1%
8	238256	10.0%
7	238171	10.0%
4	237494	10.0%
0	236283	9.9%
2	236127	9.9%
6	235751	9.9%
5	235621	9.9%
1	233982	9.8%

Lowercase Letter

Value	Count	Frequency (%)
e	238901	16.9%
a	237300	16.8%
c	236404	16.8%
b	235077	16.7%
d	232766	16.5%
f	229710	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2375922	62.8%
Latin	1410158	37.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	243136	10.2%
9	241101	10.1%
8	238256	10.0%
7	238171	10.0%
4	237494	10.0%
0	236283	9.9%
2	236127	9.9%
6	235751	9.9%
5	235621	9.9%
1	233982	9.8%

Latin

Value	Count	Frequency (%)
e	238901	16.9%
a	237300	16.8%
c	236404	16.8%
b	235077	16.7%
d	232766	16.5%
f	229710	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	243136	6.4%
9	241101	6.4%
e	238901	6.3%
8	238256	6.3%
7	238171	6.3%
4	237494	6.3%
a	237300	6.3%
c	236404	6.2%
0	236283	6.2%
2	236127	6.2%
Other values (6)	1402907	37.1%

seller_id
Categorical

HIGH CARDINALITY

Distinct	3095
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

4a3ca9315b744ce9f8e9374361493884	2155
6560211a19b47992c3666cc44a7e94c0	2130
1f50f920176fa81dab994f9023523100	2017
cc419e0650a3c5ba77189a1882b7556a	1893
da8622b14eb17ae2831f4ac5b9dab84a	1662
Other values (3090)	108458

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	487 ?
Unique (%)	0.4%

Sample

1st row	48436dade18ac8b2bce089ec2a041202
2nd row	48436dade18ac8b2bce089ec2a041202
3rd row	48436dade18ac8b2bce089ec2a041202
4th row	48436dade18ac8b2bce089ec2a041202
5th row	48436dade18ac8b2bce089ec2a041202

Common Values

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2155	1.8%
6560211a19b47992c3666cc44a7e94c0	2130	1.8%
1f50f920176fa81dab994f9023523100	2017	1.7%
cc419e0650a3c5ba77189a1882b7556a	1893	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1662	1.4%
955fee9216a65b617aa5c0531780ce60	1530	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1477	1.2%
7c67e1448b00f6e969d365cea6b010ab	1463	1.2%
7a67c85e85bb2ce8582c35f2203ad736	1245	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1240	1.0%
Other values (3085)	101503	85.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2155	1.8%
6560211a19b47992c3666cc44a7e94c0	2130	1.8%
1f50f920176fa81dab994f9023523100	2017	1.7%
cc419e0650a3c5ba77189a1882b7556a	1893	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1662	1.4%
955fee9216a65b617aa5c0531780ce60	1530	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1477	1.2%
7c67e1448b00f6e969d365cea6b010ab	1463	1.2%
7a67c85e85bb2ce8582c35f2203ad736	1245	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1240	1.0%
Other values (3085)	101503	85.8%

Most occurring characters

Value	Count	Frequency (%)
1	256849	6.8%
c	250008	6.6%
4	248500	6.6%
6	243523	6.4%
0	242859	6.4%
a	241366	6.4%
b	240804	6.4%
3	240746	6.4%
9	235028	6.2%
2	233712	6.2%
Other values (6)	1352685	35.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2394716	63.3%
Lowercase Letter	1391364	36.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	256849	10.7%
4	248500	10.4%
6	243523	10.2%
0	242859	10.1%
3	240746	10.1%
9	235028	9.8%
2	233712	9.8%
8	231762	9.7%
5	231061	9.6%
7	230676	9.6%

Lowercase Letter

Value	Count	Frequency (%)
c	250008	18.0%
a	241366	17.3%
b	240804	17.3%
e	222610	16.0%
f	219175	15.8%
d	217401	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2394716	63.3%
Latin	1391364	36.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	256849	10.7%
4	248500	10.4%
6	243523	10.2%
0	242859	10.1%
3	240746	10.1%
9	235028	9.8%
2	233712	9.8%
8	231762	9.7%
5	231061	9.6%
7	230676	9.6%

Latin

Value	Count	Frequency (%)
c	250008	18.0%
a	241366	17.3%
b	240804	17.3%
e	222610	16.0%
f	219175	15.8%
d	217401	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	256849	6.8%
c	250008	6.6%
4	248500	6.6%
6	243523	6.4%
0	242859	6.4%
a	241366	6.4%
b	240804	6.4%
3	240746	6.4%
9	235028	6.2%
2	233712	6.2%
Other values (6)	1352685	35.7%

shipping_limit_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	93317
Distinct (%)	78.9%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017-08-14 20:43:31	63
2017-10-05 17:44:41	38
2017-04-27 09:10:13	29
2017-06-15 16:15:08	26
2018-02-27 12:28:15	24
Other values (93312)	118135

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247985
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76912 ?
Unique (%)	65.0%

Sample

1st row	2017-09-19 09:45:35
2nd row	2017-07-05 02:44:11
3rd row	2018-05-23 10:56:25
4th row	2017-08-07 18:55:08
5th row	2017-08-16 22:05:11

Common Values

Value	Count	Frequency (%)
2017-08-14 20:43:31	63	0.1%
2017-10-05 17:44:41	38	< 0.1%
2017-04-27 09:10:13	29	< 0.1%
2017-06-15 16:15:08	26	< 0.1%
2018-02-27 12:28:15	24	< 0.1%
2017-11-30 14:16:34	24	< 0.1%
2017-03-15 23:39:26	24	< 0.1%
2018-05-15 15:30:28	24	< 0.1%
2017-07-13 15:10:17	24	< 0.1%
2017-12-14 11:55:17	22	< 0.1%
Other values (93307)	118017	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-30	1753	0.7%
2017-12-07	794	0.3%
2018-04-19	729	0.3%
2018-05-10	696	0.3%
2018-01-18	689	0.3%
2018-03-08	681	0.3%
2018-08-07	678	0.3%
2018-02-22	673	0.3%
2018-03-22	670	0.3%
2018-03-01	663	0.3%
Other values (40674)	228604	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	379322	16.9%
1	364451	16.2%
2	289783	12.9%
-	236630	10.5%
:	236630	10.5%
8	118675	5.3%
	118315	5.3%
3	114155	5.1%
5	111990	5.0%
7	102126	4.5%
Other values (3)	175908	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656410	73.7%
Dash Punctuation	236630	10.5%
Other Punctuation	236630	10.5%
Space Separator	118315	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	379322	22.9%
1	364451	22.0%
2	289783	17.5%
8	118675	7.2%
3	114155	6.9%
5	111990	6.8%
7	102126	6.2%
4	79403	4.8%
6	49606	3.0%
9	46899	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	236630	100.0%

Space Separator

Value	Count	Frequency (%)
	118315	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247985	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	379322	16.9%
1	364451	16.2%
2	289783	12.9%
-	236630	10.5%
:	236630	10.5%
8	118675	5.3%
	118315	5.3%
3	114155	5.1%
5	111990	5.0%
7	102126	4.5%
Other values (3)	175908	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	379322	16.9%
1	364451	16.2%
2	289783	12.9%
-	236630	10.5%
:	236630	10.5%
8	118675	5.3%
	118315	5.3%
3	114155	5.1%
5	111990	5.0%
7	102126	4.5%
Other values (3)	175908	7.8%

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5968
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.651027

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	184.1096263
Coefficient of variation (CV)	1.525968165
Kurtosis	119.1492968
Mean	120.651027
Median Absolute Deviation (MAD)	42
Skewness	7.892242206
Sum	14274826.26
Variance	33896.35449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2619	2.2%
69.9	2113	1.8%
49.9	2051	1.7%
89.9	1644	1.4%
99.9	1526	1.3%
39.9	1403	1.2%
29.9	1387	1.2%
19.9	1284	1.1%
79.9	1282	1.1%
29.99	1228	1.0%
Other values (5958)	101778	86.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3	2	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%

freight_value
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	6999
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.03302362

Minimum	0
Maximum	409.68
Zeros	390
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.28
Q3	21.18
95-th percentile	45.3
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.1

Descriptive statistics

Standard deviation	15.8365227
Coefficient of variation (CV)	0.7905208419
Kurtosis	57.63691305
Mean	20.03302362
Median Absolute Deviation (MAD)	3.63
Skewness	5.543441345
Sum	2370207.19
Variance	250.7954513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3861	3.3%
7.78	2355	2.0%
11.85	1999	1.7%
14.1	1992	1.7%
18.23	1632	1.4%
7.39	1573	1.3%
16.11	1211	1.0%
15.23	1064	0.9%
8.72	970	0.8%
16.79	930	0.8%
Other values (6989)	100728	85.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	390	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	9	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

payment_sequential
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.09406246

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	29
Range	28
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.728555048
Coefficient of variation (CV)	0.6659172345
Kurtosis	346.9364476
Mean	1.09406246
Median Absolute Deviation (MAD)	0
Skewness	15.89992468
Sum	129444
Variance	0.530792458
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	113230	95.7%
2	3389	2.9%
3	651	0.6%
4	316	0.3%
5	190	0.2%
6	132	0.1%
7	91	0.1%
8	60	0.1%
9	49	< 0.1%
10	41	< 0.1%
Other values (19)	166	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	113230	95.7%
2	3389	2.9%
3	651	0.6%
4	316	0.3%
5	190	0.2%
6	132	0.1%
7	91	0.1%
8	60	0.1%
9	49	< 0.1%
10	41	< 0.1%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	2	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	6	< 0.1%
20	6	< 0.1%

payment_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

credit_card	87266
boleto	23018
voucher	6332
debit_card	1699

Length

Max length	11
Median length	11
Mean length	9.79882517
Min length	6

Characters and Unicode

Total characters	1159348
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	boleto
3rd row	credit_card
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	87266	73.8%
boleto	23018	19.5%
voucher	6332	5.4%
debit_card	1699	1.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
credit_card	87266	73.8%
boleto	23018	19.5%
voucher	6332	5.4%
debit_card	1699	1.4%

Most occurring characters

Value	Count	Frequency (%)
c	182563	15.7%
r	182563	15.7%
d	177930	15.3%
e	118315	10.2%
t	111983	9.7%
i	88965	7.7%
_	88965	7.7%
a	88965	7.7%
o	52368	4.5%
b	24717	2.1%
Other values (4)	42014	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1070383	92.3%
Connector Punctuation	88965	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	182563	17.1%
r	182563	17.1%
d	177930	16.6%
e	118315	11.1%
t	111983	10.5%
i	88965	8.3%
a	88965	8.3%
o	52368	4.9%
b	24717	2.3%
l	23018	2.2%
Other values (3)	18996	1.8%

Connector Punctuation

Value	Count	Frequency (%)
_	88965	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1070383	92.3%
Common	88965	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	182563	17.1%
r	182563	17.1%
d	177930	16.6%
e	118315	11.1%
t	111983	10.5%
i	88965	8.3%
a	88965	8.3%
o	52368	4.9%
b	24717	2.3%
l	23018	2.2%
Other values (3)	18996	1.8%

Common

Value	Count	Frequency (%)
_	88965	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1159348	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	182563	15.7%
r	182563	15.7%
d	177930	15.3%
e	118315	10.2%
t	111983	9.7%
i	88965	7.7%
_	88965	7.7%
a	88965	7.7%
o	52368	4.5%
b	24717	2.1%
Other values (4)	42014	3.6%

payment_installments
Real number (ℝ_≥0)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.943498288

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.778022129
Coefficient of variation (CV)	0.943782485
Kurtosis	2.506924009
Mean	2.943498288
Median Absolute Deviation (MAD)	1
Skewness	1.618521535
Sum	348260
Variance	7.717406951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	58945	49.8%
2	13768	11.6%
3	11831	10.0%
4	8025	6.8%
10	6923	5.9%
5	6058	5.1%
8	5108	4.3%
6	4653	3.9%
7	1837	1.6%
9	730	0.6%
Other values (14)	437	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	58945	49.8%
2	13768	11.6%
3	11831	10.0%
4	8025	6.8%
5	6058	5.1%
6	4653	3.9%
7	1837	1.6%
8	5108	4.3%
9	730	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	21	< 0.1%
18	38	< 0.1%
17	7	< 0.1%
16	7	< 0.1%
15	93	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	28938
Distinct (%)	24.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.575651

Minimum	0
Maximum	13664.08
Zeros	6
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	27.19
Q1	60.85
median	108.2
Q3	189.26
95-th percentile	514.766
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.41

Descriptive statistics

Standard deviation	267.1046609
Coefficient of variation (CV)	1.547754039
Kurtosis	508.217825
Mean	172.575651
Median Absolute Deviation (MAD)	56.64
Skewness	14.08641401
Sum	20418288.15
Variance	71344.8999
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	350	0.3%
100	299	0.3%
20	285	0.2%
77.57	250	0.2%
35	163	0.1%
73.34	159	0.1%
30	136	0.1%
116.94	132	0.1%
56.78	122	0.1%
107.78	119	0.1%
Other values (28928)	116300	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	2	< 0.1%
0.14	5	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6922.21	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%

product_category_name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	73
Distinct (%)	0.1%
Missing	1709
Missing (%)	1.4%
Memory size	8.9 MiB

cama_mesa_banho	11990
beleza_saude	10030
esporte_lazer	9005
moveis_decoracao	8833
informatica_acessorios	8151
Other values (68)	68597

Length

Max length	46
Median length	15
Mean length	14.87630139
Min length	3

Characters and Unicode

Total characters	1734666
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cool_stuff
2nd row	cool_stuff
3rd row	cool_stuff
4th row	cool_stuff
5th row	cool_stuff

Common Values

Value	Count	Frequency (%)
cama_mesa_banho	11990	10.1%
beleza_saude	10030	8.5%
esporte_lazer	9005	7.6%
moveis_decoracao	8833	7.5%
informatica_acessorios	8151	6.9%
utilidades_domesticas	7380	6.2%
relogios_presentes	6213	5.3%
telefonia	4726	4.0%
ferramentas_jardim	4590	3.9%
automotivo	4400	3.7%
Other values (63)	41288	34.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cama_mesa_banho	11990	10.3%
beleza_saude	10030	8.6%
esporte_lazer	9005	7.7%
moveis_decoracao	8833	7.6%
informatica_acessorios	8151	7.0%
utilidades_domesticas	7380	6.3%
relogios_presentes	6213	5.3%
telefonia	4726	4.1%
ferramentas_jardim	4590	3.9%
automotivo	4400	3.8%
Other values (63)	41288	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	210548	12.1%
a	208844	12.0%
s	172862	10.0%
o	171626	9.9%
i	115177	6.6%
r	111462	6.4%
_	110499	6.4%
t	83293	4.8%
c	82443	4.8%
m	78690	4.5%
Other values (18)	389222	22.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1623865	93.6%
Connector Punctuation	110499	6.4%
Decimal Number	302	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	210548	13.0%
a	208844	12.9%
s	172862	10.6%
o	171626	10.6%
i	115177	7.1%
r	111462	6.9%
t	83293	5.1%
c	82443	5.1%
m	78690	4.8%
n	59162	3.6%
Other values (16)	329758	20.3%

Connector Punctuation

Value	Count	Frequency (%)
_	110499	100.0%

Decimal Number

Value	Count	Frequency (%)
2	302	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1623865	93.6%
Common	110801	6.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	210548	13.0%
a	208844	12.9%
s	172862	10.6%
o	171626	10.6%
i	115177	7.1%
r	111462	6.9%
t	83293	5.1%
c	82443	5.1%
m	78690	4.8%
n	59162	3.6%
Other values (16)	329758	20.3%

Common

Value	Count	Frequency (%)
_	110499	99.7%
2	302	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1734666	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	210548	12.1%
a	208844	12.0%
s	172862	10.0%
o	171626	9.9%
i	115177	6.6%
r	111462	6.4%
_	110499	6.4%
t	83293	4.8%
c	82443	4.8%
m	78690	4.5%
Other values (18)	389222	22.4%

product_name_lenght
Real number (ℝ_≥0)

MISSING

Distinct	66
Distinct (%)	0.1%
Missing	1709
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	48.7677821

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.03337512
Coefficient of variation (CV)	0.2057377778
Kurtosis	0.1496973763
Mean	48.7677821
Median Absolute Deviation (MAD)	6
Skewness	-0.9049602992
Sum	5686616
Variance	100.6686163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8679	7.3%
60	8071	6.8%
56	6847	5.8%
58	6819	5.8%
57	6302	5.3%
55	5834	4.9%
54	5531	4.7%
53	4357	3.7%
52	4328	3.7%
49	3690	3.1%
Other values (56)	56148	47.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	15	< 0.1%
10	9	< 0.1%
11	11	< 0.1%
12	38	< 0.1%
13	26	< 0.1%
14	47	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	3	< 0.1%
66	1	< 0.1%
64	174	0.1%
63	1350	1.1%
62	167	0.1%
61	241	0.2%

product_description_lenght
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	2960
Distinct (%)	2.5%
Missing	1709
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	785.944008

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	4
5-th percentile	160
Q1	346
median	600
Q3	983
95-th percentile	2123
Maximum	3992
Range	3988
Interquartile range (IQR)	637

Descriptive statistics

Standard deviation	652.5786361
Coefficient of variation (CV)	0.8303118662
Kurtosis	4.930172973
Mean	785.944008
Median Absolute Deviation (MAD)	296
Skewness	2.012211344
Sum	91645787
Variance	425858.8762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	711	0.6%
1893	667	0.6%
348	648	0.5%
903	594	0.5%
492	594	0.5%
245	587	0.5%
366	537	0.5%
236	516	0.4%
340	487	0.4%
919	442	0.4%
Other values (2950)	110823	93.7%
(Missing)	1709	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ_≥0)

MISSING

Distinct	19
Distinct (%)	< 0.1%
Missing	1709
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	2.205143818

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.717429086
Coefficient of variation (CV)	0.7788286064
Kurtosis	4.820243289
Mean	2.205143818
Median Absolute Deviation (MAD)	0
Skewness	1.908767007
Sum	257133
Variance	2.949562667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	58960	49.8%
2	23054	19.5%
3	12980	11.0%
4	8863	7.5%
5	5599	4.7%
6	3945	3.3%
7	1560	1.3%
8	774	0.7%
10	354	0.3%
9	318	0.3%
Other values (9)	199	0.2%
(Missing)	1709	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	58960	49.8%
2	23054	19.5%
3	12980	11.0%
4	8863	7.5%
5	5599	4.7%
6	3945	3.3%
7	1560	1.3%
8	774	0.7%
9	318	0.3%
10	354	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	73	0.1%
10	354	0.3%

product_weight_g
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2204
Distinct (%)	1.9%
Missing	20
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2112.331011

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3786.717861
Coefficient of variation (CV)	1.792672569
Kurtosis	16.0168339
Mean	2112.331011
Median Absolute Deviation (MAD)	500
Skewness	3.582890275
Sum	249878197
Variance	14339232.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	7093	6.0%
150	5411	4.6%
250	4741	4.0%
300	4430	3.7%
400	3787	3.2%
100	3666	3.1%
350	3291	2.8%
500	2856	2.4%
600	2838	2.4%
700	2149	1.8%
Other values (2194)	78033	66.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	991	0.8%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	303	0.3%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	99
Distinct (%)	0.1%
Missing	20
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	30.26522676

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.18903807
Coefficient of variation (CV)	0.53490556
Kurtosis	3.678790799
Mean	30.26522676
Median Absolute Deviation (MAD)	8
Skewness	1.745703959
Sum	3580225
Variance	262.0849537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	18362	15.5%
20	10999	9.3%
30	7952	6.7%
17	6203	5.2%
18	5909	5.0%
19	4898	4.1%
25	4871	4.1%
40	4360	3.7%
22	4000	3.4%
50	3163	2.7%
Other values (89)	47578	40.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	60	0.1%
14	138	0.1%
15	220	0.2%
16	18362	15.5%

Value	Count	Frequency (%)
105	335	0.3%
104	35	< 0.1%
103	46	< 0.1%
102	60	0.1%
101	108	0.1%
100	429	0.4%
99	36	< 0.1%
98	50	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	102
Distinct (%)	0.1%
Missing	20
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	16.6200093

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.45394074
Coefficient of variation (CV)	0.8095026001
Kurtosis	7.276747824
Mean	16.6200093
Median Absolute Deviation (MAD)	6
Skewness	2.238831941
Sum	1966064
Variance	181.0085215
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10374	8.8%
20	6915	5.8%
15	6896	5.8%
12	6523	5.5%
11	6432	5.4%
2	5254	4.4%
4	4911	4.2%
8	4873	4.1%
5	4776	4.0%
16	4762	4.0%
Other values (92)	56579	47.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	5254	4.4%
3	2821	2.4%
4	4911	4.2%
5	4776	4.0%
6	3576	3.0%
7	4387	3.7%
8	4873	4.1%
9	3408	2.9%
10	10374	8.8%
11	6432	5.4%

Value	Count	Frequency (%)
105	139	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	43	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	95
Distinct (%)	0.1%
Missing	20
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	23.07507502

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.74931107
Coefficient of variation (CV)	0.509177589
Kurtosis	4.552246314
Mean	23.07507502
Median Absolute Deviation (MAD)	6
Skewness	1.707015517
Sum	2729666
Variance	138.0463105
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12701	10.7%
11	11146	9.4%
15	9376	7.9%
16	8808	7.4%
30	8045	6.8%
12	5711	4.8%
13	5492	4.6%
14	4846	4.1%
18	4192	3.5%
40	4158	3.5%
Other values (85)	43820	37.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	11146	9.4%
12	5711	4.8%
13	5492	4.6%
14	4846	4.1%
15	9376	7.9%

Value	Count	Frequency (%)
118	8	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

seller_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2246
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24440.7907

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13660
Q3	27946.5
95-th percentile	88308
Maximum	99730
Range	98729
Interquartile range (IQR)	21517.5

Descriptive statistics

Standard deviation	27571.67946
Coefficient of variation (CV)	1.12810096
Kurtosis	0.9376893775
Mean	24440.7907
Median Absolute Deviation (MAD)	8123
Skewness	1.556334563
Sum	2891712152
Variance	760197508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8375	7.1%
5849	2145	1.8%
15025	2098	1.8%
9015	1899	1.6%
13405	1678	1.4%
8577	1556	1.3%
4782	1549	1.3%
3204	1477	1.2%
4160	1268	1.1%
13232	1255	1.1%
Other values (2236)	95015	80.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	41	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	323	0.3%
1031	129	0.1%
1035	18	< 0.1%
1039	1	< 0.1%
1040	25	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%
98975	22	< 0.1%
98920	2	< 0.1%
98910	14	< 0.1%
98803	66	0.1%
98780	4	< 0.1%

seller_city
Categorical

HIGH CARDINALITY

Distinct	611
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

sao paulo	29294
ibitinga	8375
curitiba	3158
santo andre	3149
sao jose do rio preto	2693
Other values (606)	71646

Length

Max length	40
Median length	9
Mean length	10.10233698
Min length	2

Characters and Unicode

Total characters	1195258
Distinct characters	41
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.1%

Sample

1st row	volta redonda
2nd row	volta redonda
3rd row	volta redonda
4th row	volta redonda
5th row	volta redonda

Common Values

Value	Count	Frequency (%)
sao paulo	29294	24.8%
ibitinga	8375	7.1%
curitiba	3158	2.7%
santo andre	3149	2.7%
sao jose do rio preto	2693	2.3%
belo horizonte	2688	2.3%
rio de janeiro	2535	2.1%
guarulhos	2456	2.1%
ribeirao preto	2374	2.0%
maringa	2293	1.9%
Other values (601)	59300	50.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	36363	17.9%
paulo	29575	14.5%
ibitinga	8375	4.1%
rio	5930	2.9%
do	5524	2.7%
preto	5518	2.7%
de	4192	2.1%
jose	4085	2.0%
santo	3270	1.6%
andre	3164	1.6%
Other values (640)	97269	47.9%

Most occurring characters

Value	Count	Frequency (%)
a	198783	16.6%
o	146217	12.2%
i	102117	8.5%
	85010	7.1%
r	78219	6.5%
s	76220	6.4%
e	64172	5.4%
u	62906	5.3%
p	58420	4.9%
l	56918	4.8%
Other values (31)	266276	22.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1109029	92.8%
Space Separator	85010	7.1%
Other Punctuation	614	0.1%
Modifier Symbol	369	< 0.1%
Dash Punctuation	164	< 0.1%
Open Punctuation	31	< 0.1%
Close Punctuation	31	< 0.1%
Decimal Number	8	< 0.1%
Nonspacing Mark	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	198783	17.9%
o	146217	13.2%
i	102117	9.2%
r	78219	7.1%
s	76220	6.9%
e	64172	5.8%
u	62906	5.7%
p	58420	5.3%
l	56918	5.1%
t	47317	4.3%
Other values (14)	217740	19.6%

Other Punctuation

Value	Count	Frequency (%)
'	347	56.5%
/	141	23.0%
.	76	12.4%
@	38	6.2%
,	6	1.0%
\	6	1.0%

Decimal Number

Value	Count	Frequency (%)
4	2	25.0%
2	2	25.0%
5	2	25.0%
0	1	12.5%
8	1	12.5%

Space Separator

Value	Count	Frequency (%)
	85010	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	369	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	164	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	31	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	31	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1109029	92.8%
Common	86227	7.2%
Inherited	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	198783	17.9%
o	146217	13.2%
i	102117	9.2%
r	78219	7.1%
s	76220	6.9%
e	64172	5.8%
u	62906	5.7%
p	58420	5.3%
l	56918	5.1%
t	47317	4.3%
Other values (14)	217740	19.6%

Common

Value	Count	Frequency (%)
	85010	98.6%
´	369	0.4%
'	347	0.4%
-	164	0.2%
/	141	0.2%
.	76	0.1%
@	38	< 0.1%
(	31	< 0.1%
)	31	< 0.1%
,	6	< 0.1%
Other values (6)	14	< 0.1%

Inherited

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1194887	> 99.9%
Latin 1 Sup	369	< 0.1%
Diacriticals	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	198783	16.6%
o	146217	12.2%
i	102117	8.5%
	85010	7.1%
r	78219	6.5%
s	76220	6.4%
e	64172	5.4%
u	62906	5.3%
p	58420	4.9%
l	56918	4.8%
Other values (29)	265905	22.3%

Latin 1 Sup

Value	Count	Frequency (%)
´	369	100.0%

Diacriticals

Value	Count	Frequency (%)
̃	2	100.0%

seller_state
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

SP	84384
MG	9314
PR	9094
RJ	5036
SC	4271
Other values (18)	6216

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236630
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	84384	71.3%
MG	9314	7.9%
PR	9094	7.7%
RJ	5036	4.3%
SC	4271	3.6%
RS	2294	1.9%
DF	949	0.8%
BA	700	0.6%
GO	550	0.5%
PE	465	0.4%
Other values (13)	1258	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	84384	71.3%
mg	9314	7.9%
pr	9094	7.7%
rj	5036	4.3%
sc	4271	3.6%
rs	2294	1.9%
df	949	0.8%
ba	700	0.6%
go	550	0.5%
pe	465	0.4%
Other values (13)	1258	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	94007	39.7%
S	91409	38.6%
R	16494	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	236630	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	94007	39.7%
S	91409	38.6%
R	16494	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	236630	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	94007	39.7%
S	91409	38.6%
R	16494	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	236630	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	94007	39.7%
S	91409	38.6%
R	16494	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

review_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98452
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

eef5dbca8d37dfce6db7d7b16dd0525e	63
7145a6f0d38ec713897856cbdcfcdb7f	38
f28281373ab8815bafafe371218f02ce	29
8823bba1e3301fee652eb06de8ef9435	26
cc074f1c33940c4f0dd904705f98e39e	24
Other values (98447)	118135

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85382 ?
Unique (%)	72.2%

Sample

1st row	97ca439bc427b48bc1cd7177abe71365
2nd row	b11cba360bbe71410c291b764753d37f
3rd row	af01c4017c5ab46df6cc810e069e654a
4th row	8304ff37d8b16b57086fa283fe0c44f8
5th row	426f43a82185969503fb3c86241a9535

Common Values

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
f28281373ab8815bafafe371218f02ce	29	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (98442)	118020	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
f28281373ab8815bafafe371218f02ce	29	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (98442)	118020	99.8%

Most occurring characters

Value	Count	Frequency (%)
a	237429	6.3%
6	237329	6.3%
5	237083	6.3%
b	237015	6.3%
d	236979	6.3%
8	236859	6.3%
f	236814	6.3%
1	236665	6.3%
0	236561	6.2%
7	236489	6.2%
Other values (6)	1416857	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2365058	62.5%
Lowercase Letter	1421022	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	237329	10.0%
5	237083	10.0%
8	236859	10.0%
1	236665	10.0%
0	236561	10.0%
7	236489	10.0%
2	236385	10.0%
9	236079	10.0%
3	235922	10.0%
4	235686	10.0%

Lowercase Letter

Value	Count	Frequency (%)
a	237429	16.7%
b	237015	16.7%
d	236979	16.7%
f	236814	16.7%
c	236419	16.6%
e	236366	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2365058	62.5%
Latin	1421022	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	237329	10.0%
5	237083	10.0%
8	236859	10.0%
1	236665	10.0%
0	236561	10.0%
7	236489	10.0%
2	236385	10.0%
9	236079	10.0%
3	235922	10.0%
4	235686	10.0%

Latin

Value	Count	Frequency (%)
a	237429	16.7%
b	237015	16.7%
d	236979	16.7%
f	236814	16.7%
c	236419	16.6%
e	236366	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	237429	6.3%
6	237329	6.3%
5	237083	6.3%
b	237015	6.3%
d	236979	6.3%
8	236859	6.3%
f	236814	6.3%
1	236665	6.3%
0	236561	6.2%
7	236489	6.2%
Other values (6)	1416857	37.4%

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.4 MiB

5	66370
4	22352
1	15427
3	9965
2	4201

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	118315
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	5
3rd row	4
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

Most occurring characters

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	118315	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	118315	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118315	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	66370	56.1%
4	22352	18.9%
1	15427	13.0%
3	9965	8.4%
2	4201	3.6%

review_comment_title
Categorical

HIGH CARDINALITY
MISSING

Distinct	4569
Distinct (%)	32.4%
Missing	104226
Missing (%)	88.1%
Memory size	5.1 MiB

Recomendo	498
recomendo	404
Bom	332
super recomendo	311
Excelente	293
Other values (4564)	12251

Length

Max length	26
Median length	11
Mean length	12.23379942
Min length	1

Characters and Unicode

Total characters	172362
Distinct characters	126
Distinct categories	14 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3120 ?
Unique (%)	22.1%

Sample

1st row	super recomendo
2nd row	O produto não foi entregu
3rd row	Muito bom
4th row	Muito bom
5th row	qualidade ruim do produto

Common Values

Value	Count	Frequency (%)
Recomendo	498	0.4%
recomendo	404	0.3%
Bom	332	0.3%
super recomendo	311	0.3%
Excelente	293	0.2%
Muito bom	279	0.2%
Ótimo	268	0.2%
Super recomendo	257	0.2%
Ótimo	238	0.2%
Otimo	201	0.2%
Other values (4559)	11008	9.3%
(Missing)	104226	88.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
recomendo	2485	9.2%
produto	1589	5.9%
bom	1528	5.7%
super	1043	3.9%
muito	1042	3.9%
não	951	3.5%
ótimo	807	3.0%
excelente	769	2.8%
entrega	728	2.7%
recebi	450	1.7%
Other values (2112)	15603	57.8%

Most occurring characters

Value	Count	Frequency (%)
o	21420	12.4%
e	18455	10.7%
	15344	8.9%
r	10013	5.8%
t	9486	5.5%
a	9268	5.4%
m	8473	4.9%
d	8290	4.8%
i	8146	4.7%
n	7741	4.5%
Other values (116)	55726	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	133893	77.7%
Uppercase Letter	19045	11.0%
Space Separator	15344	8.9%
Other Punctuation	2703	1.6%
Decimal Number	1270	0.7%
Other Symbol	49	< 0.1%
Dash Punctuation	19	< 0.1%
Modifier Symbol	13	< 0.1%
Math Symbol	8	< 0.1%
Close Punctuation	7	< 0.1%
Other values (4)	11	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	21420	16.0%
e	18455	13.8%
r	10013	7.5%
t	9486	7.1%
a	9268	6.9%
m	8473	6.3%
d	8290	6.2%
i	8146	6.1%
n	7741	5.8%
c	5992	4.5%
Other values (31)	26609	19.9%

Uppercase Letter

Value	Count	Frequency (%)
E	2553	13.4%
R	2065	10.8%
O	1693	8.9%
P	1632	8.6%
M	1457	7.7%
N	1214	6.4%
S	1057	5.6%
A	994	5.2%
Ó	931	4.9%
B	902	4.7%
Other values (26)	4547	23.9%

Other Punctuation

Value	Count	Frequency (%)
!	1213	44.9%
.	801	29.6%
*	404	14.9%
,	155	5.7%
?	50	1.8%
/	39	1.4%
%	22	0.8%
:	6	0.2%
;	4	0.1%
"	3	0.1%
Other values (4)	6	0.2%

Other Symbol

Value	Count	Frequency (%)
👍	16	32.7%
😍	9	18.4%
👏	7	14.3%
🌟	6	12.2%
💥	5	10.2%
🚚	1	2.0%
😀	1	2.0%
🔟	1	2.0%
👎	1	2.0%
🤗	1	2.0%

Decimal Number

Value	Count	Frequency (%)
0	484	38.1%
1	424	33.4%
5	81	6.4%
2	80	6.3%
8	46	3.6%
3	42	3.3%
4	39	3.1%
9	29	2.3%
7	24	1.9%
6	21	1.7%

Modifier Symbol

Value	Count	Frequency (%)
´	6	46.2%
🏻	3	23.1%
🏽	2	15.4%
🏼	2	15.4%

Close Punctuation

Value	Count	Frequency (%)
)	6	85.7%
]	1	14.3%

Math Symbol

Value	Count	Frequency (%)
+	7	87.5%
=	1	12.5%

Space Separator

Value	Count	Frequency (%)
	15344	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	19	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	5	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Other Letter

Value	Count	Frequency (%)
ª	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	152939	88.7%
Common	19423	11.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	21420	14.0%
e	18455	12.1%
r	10013	6.5%
t	9486	6.2%
a	9268	6.1%
m	8473	5.5%
d	8290	5.4%
i	8146	5.3%
n	7741	5.1%
c	5992	3.9%
Other values (68)	45655	29.9%

Common

Value	Count	Frequency (%)
	15344	79.0%
!	1213	6.2%
.	801	4.1%
0	484	2.5%
1	424	2.2%
*	404	2.1%
,	155	0.8%
5	81	0.4%
2	80	0.4%
?	50	0.3%
Other values (38)	387	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	168670	97.9%
Latin 1 Sup	3636	2.1%
None	45	< 0.1%
Emoticons	11	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	21420	12.7%
e	18455	10.9%
	15344	9.1%
r	10013	5.9%
t	9486	5.6%
a	9268	5.5%
m	8473	5.0%
d	8290	4.9%
i	8146	4.8%
n	7741	4.6%
Other values (75)	52034	30.8%

Latin 1 Sup

Value	Count	Frequency (%)
ã	1144	31.5%
Ó	931	25.6%
á	361	9.9%
ç	358	9.8%
é	275	7.6%
ó	247	6.8%
Ã	74	2.0%
í	64	1.8%
ê	45	1.2%
É	30	0.8%
Other values (17)	107	2.9%

Emoticons

Value	Count	Frequency (%)
😍	9	81.8%
😀	1	9.1%
😤	1	9.1%

None

Value	Count	Frequency (%)
👍	16	35.6%
👏	7	15.6%
🌟	6	13.3%
💥	5	11.1%
🏻	3	6.7%
🏽	2	4.4%
🏼	2	4.4%
🚚	1	2.2%
🔟	1	2.2%
👎	1	2.2%

review_comment_message
Categorical

HIGH CARDINALITY
MISSING

Distinct	36434
Distinct (%)	71.9%
Missing	67650
Missing (%)	57.2%
Memory size	9.9 MiB

Muito bom	259
Bom	207
muito bom	137
bom	118
Otimo	116
Other values (36429)	49828

Length

Max length	208
Median length	55
Mean length	71.77513076
Min length	1

Characters and Unicode

Total characters	3636487
Distinct characters	212
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29741 ?
Unique (%)	58.7%

Sample

1st row	Perfeito, produto entregue antes do combinado.
2nd row	lannister como sempre, entregou certinho e dentro do prazo. recomendo muito
3rd row	carrinho muito bonito
4th row	Muito bom chegou bem antes do prazo, produto de ótima qualidade meu filho amou
5th row	o carrinho veio com defeito.

Common Values

Value	Count	Frequency (%)
Muito bom	259	0.2%
Bom	207	0.2%
muito bom	137	0.1%
bom	118	0.1%
Otimo	116	0.1%
Recomendo	111	0.1%
otimo	103	0.1%
Ok	87	0.1%
Ótimo	86	0.1%
Ótimo	85	0.1%
Other values (36424)	49356	41.7%
(Missing)	67650	57.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
o	23487	3.8%
produto	21348	3.4%
e	20473	3.3%
a	15615	2.5%
de	14952	2.4%
não	13630	2.2%
do	13273	2.1%
que	10862	1.8%
prazo	9452	1.5%
muito	9205	1.5%
Other values (20373)	468376	75.5%

Most occurring characters

Value	Count	Frequency (%)
	576384	15.9%
o	357423	9.8%
e	348604	9.6%
a	287966	7.9%
r	204653	5.6%
i	167459	4.6%
t	164244	4.5%
d	153473	4.2%
n	141236	3.9%
s	136679	3.8%
Other values (202)	1098366	30.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2740678	75.4%
Space Separator	576384	15.9%
Uppercase Letter	176403	4.9%
Other Punctuation	98665	2.7%
Decimal Number	25898	0.7%
Control	14569	0.4%
Dash Punctuation	1207	< 0.1%
Close Punctuation	784	< 0.1%
Open Punctuation	768	< 0.1%
Other Symbol	718	< 0.1%
Other values (5)	413	< 0.1%

Most frequent character per category

Other Symbol

Value	Count	Frequency (%)
👏	242	33.7%
👍	86	12.0%
😍	76	10.6%
°	34	4.7%
😡	24	3.3%
😉	23	3.2%
😘	20	2.8%
😆	19	2.6%
👎	15	2.1%
😁	13	1.8%
Other values (57)	166	23.1%

Lowercase Letter

Value	Count	Frequency (%)
o	357423	13.0%
e	348604	12.7%
a	287966	10.5%
r	204653	7.5%
i	167459	6.1%
t	164244	6.0%
d	153473	5.6%
n	141236	5.2%
s	136679	5.0%
m	131074	4.8%
Other values (40)	647867	23.6%

Uppercase Letter

Value	Count	Frequency (%)
E	20985	11.9%
O	19705	11.2%
A	18252	10.3%
P	12919	7.3%
R	12763	7.2%
C	10218	5.8%
N	10187	5.8%
M	9741	5.5%
S	8676	4.9%
T	8257	4.7%
Other values (31)	44700	25.3%

Other Punctuation

Value	Count	Frequency (%)
.	51762	52.5%
,	28993	29.4%
!	12925	13.1%
/	1921	1.9%
?	1653	1.7%
"	434	0.4%
:	385	0.4%
;	226	0.2%
%	196	0.2%
*	82	0.1%
Other values (6)	88	0.1%

Decimal Number

Value	Count	Frequency (%)
0	5665	21.9%
1	5482	21.2%
2	4706	18.2%
3	2532	9.8%
4	1701	6.6%
5	1569	6.1%
6	1227	4.7%
8	1202	4.6%
7	1035	4.0%
9	779	3.0%

Math Symbol

Value	Count	Frequency (%)
+	90	57.0%
=	32	20.3%
\|	12	7.6%
<	10	6.3%
~	9	5.7%
×	2	1.3%
>	2	1.3%
÷	1	0.6%

Modifier Symbol

Value	Count	Frequency (%)
🏻	34	33.3%
´	26	25.5%
🏼	15	14.7%
🏽	13	12.7%
^	8	7.8%
🏾	4	3.9%
`	2	2.0%

Control

Value	Count	Frequency (%)
	7277	49.9%
	7271	49.9%
	21	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	762	99.2%
[	6	0.8%

Close Punctuation

Value	Count	Frequency (%)
)	781	99.6%
]	3	0.4%

Other Letter

Value	Count	Frequency (%)
º	31	59.6%
ª	21	40.4%

Space Separator

Value	Count	Frequency (%)
	576384	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1207	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	14	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	87	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2917133	80.2%
Common	719354	19.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
	576384	80.1%
.	51762	7.2%
,	28993	4.0%
!	12925	1.8%
	7277	1.0%
	7271	1.0%
0	5665	0.8%
1	5482	0.8%
2	4706	0.7%
3	2532	0.4%
Other values (109)	16357	2.3%

Latin

Value	Count	Frequency (%)
o	357423	12.3%
e	348604	12.0%
a	287966	9.9%
r	204653	7.0%
i	167459	5.7%
t	164244	5.6%
d	153473	5.3%
n	141236	4.8%
s	136679	4.7%
m	131074	4.5%
Other values (83)	824322	28.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3570160	98.2%
Latin 1 Sup	65570	1.8%
None	491	< 0.1%
Emoticons	259	< 0.1%
Latin Ext A	7	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	576384	16.1%
o	357423	10.0%
e	348604	9.8%
a	287966	8.1%
r	204653	5.7%
i	167459	4.7%
t	164244	4.6%
d	153473	4.3%
n	141236	4.0%
s	136679	3.8%
Other values (86)	1032039	28.9%

Latin 1 Sup

Value	Count	Frequency (%)
ã	19563	29.8%
é	11815	18.0%
á	9368	14.3%
ç	8039	12.3%
ó	6440	9.8%
ê	2027	3.1%
í	1812	2.8%
Ó	1569	2.4%
ú	954	1.5%
õ	945	1.4%
Other values (33)	3038	4.6%

Emoticons

Value	Count	Frequency (%)
😍	76	29.3%
😡	24	9.3%
😉	23	8.9%
😘	20	7.7%
😆	19	7.3%
😁	13	5.0%
😊	12	4.6%
😀	8	3.1%
😩	7	2.7%
😃	6	2.3%
Other values (22)	51	19.7%

None

Value	Count	Frequency (%)
👏	242	49.3%
👍	86	17.5%
🏻	34	6.9%
👎	15	3.1%
🏼	15	3.1%
🏽	13	2.6%
💓	11	2.2%
🔝	9	1.8%
🤗	8	1.6%
🌟	5	1.0%
Other values (28)	53	10.8%

Latin Ext A

Value	Count	Frequency (%)
ă	5	71.4%
ķ	1	14.3%
ő	1	14.3%

review_creation_date
Categorical

HIGH CARDINALITY

Distinct	633
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017-12-19 00:00:00	546
2018-05-22 00:00:00	523
2018-05-15 00:00:00	522
2017-12-20 00:00:00	517
2018-05-04 00:00:00	510
Other values (628)	115697

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247985
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	< 0.1%

Sample

1st row	2017-09-21 00:00:00
2nd row	2017-07-14 00:00:00
3rd row	2018-06-05 00:00:00
4th row	2017-08-10 00:00:00
5th row	2017-08-25 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-19 00:00:00	546	0.5%
2018-05-22 00:00:00	523	0.4%
2018-05-15 00:00:00	522	0.4%
2017-12-20 00:00:00	517	0.4%
2018-05-04 00:00:00	510	0.4%
2018-05-19 00:00:00	509	0.4%
2018-08-28 00:00:00	505	0.4%
2018-03-29 00:00:00	504	0.4%
2018-04-12 00:00:00	487	0.4%
2017-12-13 00:00:00	486	0.4%
Other values (623)	113206	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	118219	50.0%
2017-12-19	546	0.2%
2018-05-22	523	0.2%
2018-05-15	522	0.2%
2017-12-20	517	0.2%
2018-05-04	510	0.2%
2018-05-19	509	0.2%
2018-08-28	505	0.2%
2018-03-29	504	0.2%
2018-04-12	487	0.2%
Other values (625)	113788	48.1%

Most occurring characters

Value	Count	Frequency (%)
0	975204	43.4%
-	236630	10.5%
:	236630	10.5%
1	205338	9.1%
2	189022	8.4%
	118315	5.3%
8	94573	4.2%
7	74311	3.3%
3	29091	1.3%
5	25342	1.1%
Other values (3)	63529	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656410	73.7%
Dash Punctuation	236630	10.5%
Other Punctuation	236630	10.5%
Space Separator	118315	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	975204	58.9%
1	205338	12.4%
2	189022	11.4%
8	94573	5.7%
7	74311	4.5%
3	29091	1.8%
5	25342	1.5%
4	23775	1.4%
6	23455	1.4%
9	16299	1.0%

Dash Punctuation

Value	Count	Frequency (%)
-	236630	100.0%

Space Separator

Value	Count	Frequency (%)
	118315	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247985	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	975204	43.4%
-	236630	10.5%
:	236630	10.5%
1	205338	9.1%
2	189022	8.4%
	118315	5.3%
8	94573	4.2%
7	74311	3.3%
3	29091	1.3%
5	25342	1.1%
Other values (3)	63529	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	975204	43.4%
-	236630	10.5%
:	236630	10.5%
1	205338	9.1%
2	189022	8.4%
	118315	5.3%
8	94573	4.2%
7	74311	3.3%
3	29091	1.3%
5	25342	1.1%
Other values (3)	63529	2.8%

review_answer_timestamp
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98290
Distinct (%)	83.1%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017-08-17 22:17:55	63
2017-10-19 21:08:44	38
2017-05-24 16:21:27	29
2017-06-28 18:49:50	26
2017-03-23 08:34:13	24
Other values (98285)	118135

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247985
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85104 ?
Unique (%)	71.9%

Sample

1st row	2017-09-22 10:57:03
2nd row	2017-07-17 12:50:07
3rd row	2018-06-06 21:41:12
4th row	2017-08-13 03:35:17
5th row	2017-08-28 00:51:18

Common Values

Value	Count	Frequency (%)
2017-08-17 22:17:55	63	0.1%
2017-10-19 21:08:44	38	< 0.1%
2017-05-24 16:21:27	29	< 0.1%
2017-06-28 18:49:50	26	< 0.1%
2017-03-23 08:34:13	24	< 0.1%
2017-08-01 13:20:31	24	< 0.1%
2018-06-04 19:04:20	24	< 0.1%
2018-03-07 15:08:10	24	< 0.1%
2017-12-22 20:33:52	22	< 0.1%
2017-07-30 14:19:07	21	< 0.1%
Other values (98280)	118020	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-20	783	0.3%
2018-05-21	691	0.3%
2018-05-10	593	0.3%
2017-12-20	477	0.2%
2018-04-13	432	0.2%
2017-12-13	426	0.2%
2018-05-11	424	0.2%
2017-12-22	417	0.2%
2018-08-24	416	0.2%
2017-12-21	411	0.2%
Other values (53976)	231560	97.9%

Most occurring characters

Value	Count	Frequency (%)
0	378646	16.8%
1	350776	15.6%
2	299861	13.3%
-	236630	10.5%
:	236630	10.5%
8	124472	5.5%
	118315	5.3%
3	109946	4.9%
7	102187	4.5%
5	93806	4.2%
Other values (3)	196716	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656410	73.7%
Dash Punctuation	236630	10.5%
Other Punctuation	236630	10.5%
Space Separator	118315	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	378646	22.9%
1	350776	21.2%
2	299861	18.1%
8	124472	7.5%
3	109946	6.6%
7	102187	6.2%
5	93806	5.7%
4	93541	5.6%
6	53422	3.2%
9	49753	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	236630	100.0%

Space Separator

Value	Count	Frequency (%)
	118315	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247985	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	378646	16.8%
1	350776	15.6%
2	299861	13.3%
-	236630	10.5%
:	236630	10.5%
8	124472	5.5%
	118315	5.3%
3	109946	4.9%
7	102187	4.5%
5	93806	4.2%
Other values (3)	196716	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	378646	16.8%
1	350776	15.6%
2	299861	13.3%
-	236630	10.5%
:	236630	10.5%
8	124472	5.5%
	118315	5.3%
3	109946	4.9%
7	102187	4.5%
5	93806	4.2%
Other values (3)	196716	8.8%

customer_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98665
Distinct (%)	83.4%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

270c23a11d024a44c896d1894b261a83	63
13aa59158da63ba0e93ec6ac2c07aacb	38
9af2372a1e49340278e7c1ef8d749f34	29
92cd3ec6e2d643d4ebd0e3d6238f69e2	26
2ba91e12e5e4c9f56b82b86d9031d329	24
Other values (98660)	118135

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85739 ?
Unique (%)	72.5%

Sample

1st row	3ce436f183e68e07877b285a838db11a
2nd row	e6eecc5a77de221464d1c4eaff0a9b64
3rd row	4ef55bf80f711b372afebcb7c715344a
4th row	30407a72ad8b3f4df4d15369126b20c9
5th row	91a792fef70ecd8cc69d3c7feb3d12da

Common Values

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (98655)	118017	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (98655)	118017	99.7%

Most occurring characters

Value	Count	Frequency (%)
f	237304	6.3%
2	237291	6.3%
5	237079	6.3%
c	236988	6.3%
6	236914	6.3%
1	236844	6.3%
8	236669	6.3%
d	236622	6.2%
e	236620	6.2%
7	236602	6.2%
Other values (6)	1417147	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2365456	62.5%
Lowercase Letter	1420624	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	237291	10.0%
5	237079	10.0%
6	236914	10.0%
1	236844	10.0%
8	236669	10.0%
7	236602	10.0%
3	236519	10.0%
9	236477	10.0%
4	235653	10.0%
0	235408	10.0%

Lowercase Letter

Value	Count	Frequency (%)
f	237304	16.7%
c	236988	16.7%
d	236622	16.7%
e	236620	16.7%
a	236602	16.7%
b	236488	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2365456	62.5%
Latin	1420624	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	237291	10.0%
5	237079	10.0%
6	236914	10.0%
1	236844	10.0%
8	236669	10.0%
7	236602	10.0%
3	236519	10.0%
9	236477	10.0%
4	235653	10.0%
0	235408	10.0%

Latin

Value	Count	Frequency (%)
f	237304	16.7%
c	236988	16.7%
d	236622	16.7%
e	236620	16.7%
a	236602	16.7%
b	236488	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
f	237304	6.3%
2	237291	6.3%
5	237079	6.3%
c	236988	6.3%
6	236914	6.3%
1	236844	6.3%
8	236669	6.3%
d	236622	6.2%
e	236620	6.2%
7	236602	6.2%
Other values (6)	1417147	37.4%

order_status
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.3 MiB

delivered	115728
shipped	1255
canceled	570
invoiced	376
processing	376
Other values (2)	10

Length

Max length	11
Median length	9
Mean length	8.97406077
Min length	7

Characters and Unicode

Total characters	1061766
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	115728	97.8%
shipped	1255	1.1%
canceled	570	0.5%
invoiced	376	0.3%
processing	376	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
delivered	115728	97.8%
shipped	1255	1.1%
canceled	570	0.5%
invoiced	376	0.3%
processing	376	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	350341	33.0%
d	233660	22.0%
i	118118	11.1%
l	116312	11.0%
v	116114	10.9%
r	116107	10.9%
p	2892	0.3%
s	2007	0.2%
c	1892	0.2%
n	1329	0.1%
Other values (6)	2994	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1061766	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	350341	33.0%
d	233660	22.0%
i	118118	11.1%
l	116312	11.0%
v	116114	10.9%
r	116107	10.9%
p	2892	0.3%
s	2007	0.2%
c	1892	0.2%
n	1329	0.1%
Other values (6)	2994	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1061766	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	350341	33.0%
d	233660	22.0%
i	118118	11.1%
l	116312	11.0%
v	116114	10.9%
r	116107	10.9%
p	2892	0.3%
s	2007	0.2%
c	1892	0.2%
n	1329	0.1%
Other values (6)	2994	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1061766	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	350341	33.0%
d	233660	22.0%
i	118118	11.1%
l	116312	11.0%
v	116114	10.9%
r	116107	10.9%
p	2892	0.3%
s	2007	0.2%
c	1892	0.2%
n	1329	0.1%
Other values (6)	2994	0.3%

order_purchase_timestamp
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98111
Distinct (%)	82.9%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017-08-08 20:26:31	63
2017-09-23 14:56:45	38
2017-04-20 12:45:34	29
2017-06-07 12:05:10	26
2018-02-14 16:34:27	24
Other values (98106)	118135

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247985
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84913 ?
Unique (%)	71.8%

Sample

1st row	2017-09-13 08:59:02
2nd row	2017-06-28 11:52:20
3rd row	2018-05-18 10:25:53
4th row	2017-08-01 18:38:42
5th row	2017-08-10 21:48:40

Common Values

Value	Count	Frequency (%)
2017-08-08 20:26:31	63	0.1%
2017-09-23 14:56:45	38	< 0.1%
2017-04-20 12:45:34	29	< 0.1%
2017-06-07 12:05:10	26	< 0.1%
2018-02-14 16:34:27	24	< 0.1%
2018-05-12 12:28:58	24	< 0.1%
2017-07-07 14:55:43	24	< 0.1%
2017-11-25 13:54:39	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2017-10-17 13:06:29	22	< 0.1%
Other values (98101)	118017	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	1425	0.6%
2017-11-25	639	0.3%
2017-11-27	504	0.2%
2017-11-26	482	0.2%
2017-11-28	449	0.2%
2018-08-06	445	0.2%
2018-05-15	441	0.2%
2018-08-07	440	0.2%
2018-05-07	429	0.2%
2018-05-14	425	0.2%
Other values (51248)	230951	97.6%

Most occurring characters

Value	Count	Frequency (%)
1	365963	16.3%
0	364100	16.2%
2	288776	12.8%
-	236630	10.5%
:	236630	10.5%
8	122682	5.5%
	118315	5.3%
7	110056	4.9%
3	104525	4.6%
5	95595	4.3%
Other values (3)	204713	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656410	73.7%
Dash Punctuation	236630	10.5%
Other Punctuation	236630	10.5%
Space Separator	118315	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	365963	22.1%
0	364100	22.0%
2	288776	17.4%
8	122682	7.4%
7	110056	6.6%
3	104525	6.3%
5	95595	5.8%
4	95495	5.8%
6	56340	3.4%
9	52878	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	236630	100.0%

Space Separator

Value	Count	Frequency (%)
	118315	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247985	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	365963	16.3%
0	364100	16.2%
2	288776	12.8%
-	236630	10.5%
:	236630	10.5%
8	122682	5.5%
	118315	5.3%
7	110056	4.9%
3	104525	4.6%
5	95595	4.3%
Other values (3)	204713	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	365963	16.3%
0	364100	16.2%
2	288776	12.8%
-	236630	10.5%
:	236630	10.5%
8	122682	5.5%
	118315	5.3%
7	110056	4.9%
3	104525	4.6%
5	95595	4.3%
Other values (3)	204713	9.1%

order_approved_at
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	90173
Distinct (%)	76.2%
Missing	15
Missing (%)	< 0.1%
Memory size	9.5 MiB

2017-08-08 20:43:31	63
2017-09-25 17:44:41	38
2017-04-22 09:10:13	29
2017-06-09 16:15:08	26
2018-05-12 15:41:58	24
Other values (90168)	118120

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247700
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72166 ?
Unique (%)	61.0%

Sample

1st row	2017-09-13 09:45:35
2nd row	2017-06-29 02:44:11
3rd row	2018-05-18 12:31:43
4th row	2017-08-01 18:55:08
5th row	2017-08-10 22:05:11

Common Values

Value	Count	Frequency (%)
2017-08-08 20:43:31	63	0.1%
2017-09-25 17:44:41	38	< 0.1%
2017-04-22 09:10:13	29	< 0.1%
2017-06-09 16:15:08	26	< 0.1%
2018-05-12 15:41:58	24	< 0.1%
2018-02-21 12:28:15	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2017-07-07 15:10:17	24	< 0.1%
2017-11-25 14:16:34	24	< 0.1%
2018-02-24 03:20:27	23	< 0.1%
Other values (90163)	118001	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-24	1163	0.5%
2017-11-24	992	0.4%
2017-11-25	939	0.4%
2018-07-05	825	0.3%
2017-11-28	602	0.3%
2018-08-07	505	0.2%
2018-05-08	494	0.2%
2018-08-20	488	0.2%
2018-05-01	487	0.2%
2018-01-22	484	0.2%
Other values (42201)	229621	97.1%

Most occurring characters

Value	Count	Frequency (%)
0	379084	16.9%
1	364095	16.2%
2	287685	12.8%
-	236600	10.5%
:	236600	10.5%
	118300	5.3%
8	116535	5.2%
5	113898	5.1%
3	110885	4.9%
7	105027	4.7%
Other values (3)	178991	8.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656200	73.7%
Dash Punctuation	236600	10.5%
Other Punctuation	236600	10.5%
Space Separator	118300	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	379084	22.9%
1	364095	22.0%
2	287685	17.4%
8	116535	7.0%
5	113898	6.9%
3	110885	6.7%
7	105027	6.3%
4	81998	5.0%
6	51103	3.1%
9	45890	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	236600	100.0%

Space Separator

Value	Count	Frequency (%)
	118300	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236600	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247700	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	379084	16.9%
1	364095	16.2%
2	287685	12.8%
-	236600	10.5%
:	236600	10.5%
	118300	5.3%
8	116535	5.2%
5	113898	5.1%
3	110885	4.9%
7	105027	4.7%
Other values (3)	178991	8.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	379084	16.9%
1	364095	16.2%
2	287685	12.8%
-	236600	10.5%
:	236600	10.5%
	118300	5.3%
8	116535	5.2%
5	113898	5.1%
3	110885	4.9%
7	105027	4.7%
Other values (3)	178991	8.0%

order_delivered_carrier_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	81016
Distinct (%)	69.2%
Missing	1254
Missing (%)	1.1%
Memory size	9.4 MiB

2017-08-10 11:58:14	63
2018-05-09 15:48:00	48
2017-10-02 23:47:54	38
2018-05-10 18:29:00	36
2018-05-14 14:25:00	32
Other values (81011)	116844

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2224159
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	61374 ?
Unique (%)	52.4%

Sample

1st row	2017-09-19 18:34:16
2nd row	2017-07-05 12:00:33
3rd row	2018-05-23 14:05:00
4th row	2017-08-02 19:07:36
5th row	2017-08-11 19:43:07

Common Values

Value	Count	Frequency (%)
2017-08-10 11:58:14	63	0.1%
2018-05-09 15:48:00	48	< 0.1%
2017-10-02 23:47:54	38	< 0.1%
2018-05-10 18:29:00	36	< 0.1%
2018-05-14 14:25:00	32	< 0.1%
2018-05-04 15:46:00	29	< 0.1%
2017-04-24 11:31:17	29	< 0.1%
2018-08-08 15:01:00	27	< 0.1%
2017-06-16 15:50:28	26	< 0.1%
2018-06-13 14:13:00	24	< 0.1%
Other values (81006)	116709	98.6%
(Missing)	1254	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-28	925	0.4%
2017-11-27	818	0.3%
2017-11-29	706	0.3%
2018-02-27	632	0.3%
2018-03-27	622	0.3%
2018-08-06	595	0.3%
2017-11-30	584	0.2%
2018-05-14	568	0.2%
2018-08-13	550	0.2%
2018-05-03	539	0.2%
Other values (37538)	227583	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	405314	18.2%
1	346875	15.6%
2	275775	12.4%
-	234122	10.5%
:	234122	10.5%
8	123414	5.5%
	117061	5.3%
7	106645	4.8%
3	98644	4.4%
4	92073	4.1%
Other values (3)	190114	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1638854	73.7%
Dash Punctuation	234122	10.5%
Other Punctuation	234122	10.5%
Space Separator	117061	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	405314	24.7%
1	346875	21.2%
2	275775	16.8%
8	123414	7.5%
7	106645	6.5%
3	98644	6.0%
4	92073	5.6%
5	89896	5.5%
6	51438	3.1%
9	48780	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	234122	100.0%

Space Separator

Value	Count	Frequency (%)
	117061	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	234122	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2224159	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	405314	18.2%
1	346875	15.6%
2	275775	12.4%
-	234122	10.5%
:	234122	10.5%
8	123414	5.5%
	117061	5.3%
7	106645	4.8%
3	98644	4.4%
4	92073	4.1%
Other values (3)	190114	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2224159	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	405314	18.2%
1	346875	15.6%
2	275775	12.4%
-	234122	10.5%
:	234122	10.5%
8	123414	5.5%
	117061	5.3%
7	106645	4.8%
3	98644	4.4%
4	92073	4.1%
Other values (3)	190114	8.5%

order_delivered_customer_date
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	95663
Distinct (%)	82.7%
Missing	2588
Missing (%)	2.2%
Memory size	9.4 MiB

2017-08-14 12:46:18	63
2017-10-18 22:35:50	38
2017-06-22 16:04:46	26
2018-06-01 15:18:45	24
2017-07-27 20:52:15	24
Other values (95658)	115552

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2198813
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82382 ?
Unique (%)	71.2%

Sample

1st row	2017-09-20 23:43:48
2nd row	2017-07-13 20:39:29
3rd row	2018-06-04 18:34:26
4th row	2017-08-09 21:26:33
5th row	2017-08-24 20:04:21

Common Values

Value	Count	Frequency (%)
2017-08-14 12:46:18	63	0.1%
2017-10-18 22:35:50	38	< 0.1%
2017-06-22 16:04:46	26	< 0.1%
2018-06-01 15:18:45	24	< 0.1%
2017-07-27 20:52:15	24	< 0.1%
2017-11-30 14:59:18	24	< 0.1%
2018-02-28 20:09:19	24	< 0.1%
2017-03-21 13:32:45	24	< 0.1%
2017-10-22 14:43:54	22	< 0.1%
2017-12-21 16:33:10	22	< 0.1%
Other values (95653)	115436	97.6%
(Missing)	2588	2.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-21	529	0.2%
2018-05-14	528	0.2%
2018-08-13	507	0.2%
2018-05-18	505	0.2%
2018-08-27	504	0.2%
2018-05-03	501	0.2%
2018-04-11	495	0.2%
2017-12-11	489	0.2%
2017-12-19	484	0.2%
2018-04-30	482	0.2%
Other values (41733)	226430	97.8%

Most occurring characters

Value	Count	Frequency (%)
1	340135	15.5%
0	336692	15.3%
2	291234	13.2%
-	231454	10.5%
:	231454	10.5%
8	135449	6.2%
	115727	5.3%
7	107269	4.9%
3	107060	4.9%
4	100138	4.6%
Other values (3)	202201	9.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620178	73.7%
Dash Punctuation	231454	10.5%
Other Punctuation	231454	10.5%
Space Separator	115727	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	340135	21.0%
0	336692	20.8%
2	291234	18.0%
8	135449	8.4%
7	107269	6.6%
3	107060	6.6%
4	100138	6.2%
5	93760	5.8%
6	58490	3.6%
9	49951	3.1%

Dash Punctuation

Value	Count	Frequency (%)
-	231454	100.0%

Space Separator

Value	Count	Frequency (%)
	115727	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	231454	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2198813	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	340135	15.5%
0	336692	15.3%
2	291234	13.2%
-	231454	10.5%
:	231454	10.5%
8	135449	6.2%
	115727	5.3%
7	107269	4.9%
3	107060	4.9%
4	100138	4.6%
Other values (3)	202201	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2198813	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	340135	15.5%
0	336692	15.3%
2	291234	13.2%
-	231454	10.5%
:	231454	10.5%
8	135449	6.2%
	115727	5.3%
7	107269	4.9%
3	107060	4.9%
4	100138	4.6%
Other values (3)	202201	9.2%

order_estimated_delivery_date
Categorical

HIGH CARDINALITY

Distinct	449
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	9.5 MiB

2017-12-20 00:00:00	656
2018-03-12 00:00:00	616
2018-03-13 00:00:00	614
2018-05-29 00:00:00	609
2018-07-16 00:00:00	590
Other values (444)	115230

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247985
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	< 0.1%

Sample

1st row	2017-09-29 00:00:00
2nd row	2017-07-26 00:00:00
3rd row	2018-06-07 00:00:00
4th row	2017-08-25 00:00:00
5th row	2017-09-01 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-20 00:00:00	656	0.6%
2018-03-12 00:00:00	616	0.5%
2018-03-13 00:00:00	614	0.5%
2018-05-29 00:00:00	609	0.5%
2018-07-16 00:00:00	590	0.5%
2018-07-05 00:00:00	588	0.5%
2018-02-14 00:00:00	587	0.5%
2018-05-28 00:00:00	583	0.5%
2018-05-30 00:00:00	582	0.5%
2017-12-19 00:00:00	582	0.5%
Other values (439)	112308	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	118315	50.0%
2017-12-20	656	0.3%
2018-03-12	616	0.3%
2018-03-13	614	0.3%
2018-05-29	609	0.3%
2018-07-16	590	0.2%
2018-07-05	588	0.2%
2018-02-14	587	0.2%
2018-05-28	583	0.2%
2018-05-30	582	0.2%
Other values (440)	112890	47.7%

Most occurring characters

Value	Count	Frequency (%)
0	978611	43.5%
-	236630	10.5%
:	236630	10.5%
1	202579	9.0%
2	184497	8.2%
	118315	5.3%
8	97763	4.3%
7	72165	3.2%
3	31712	1.4%
5	24344	1.1%
Other values (3)	64739	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656410	73.7%
Dash Punctuation	236630	10.5%
Other Punctuation	236630	10.5%
Space Separator	118315	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	978611	59.1%
1	202579	12.2%
2	184497	11.1%
8	97763	5.9%
7	72165	4.4%
3	31712	1.9%
5	24344	1.5%
6	23060	1.4%
4	22101	1.3%
9	19578	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	236630	100.0%

Space Separator

Value	Count	Frequency (%)
	118315	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247985	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	978611	43.5%
-	236630	10.5%
:	236630	10.5%
1	202579	9.0%
2	184497	8.2%
	118315	5.3%
8	97763	4.3%
7	72165	3.2%
3	31712	1.4%
5	24344	1.1%
Other values (3)	64739	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	978611	43.5%
-	236630	10.5%
:	236630	10.5%
1	202579	9.0%
2	184497	8.2%
	118315	5.3%
8	97763	4.3%
7	72165	3.2%
3	31712	1.4%
5	24344	1.1%
Other values (3)	64739	2.9%

customer_unique_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95419
Distinct (%)	80.6%
Missing	0
Missing (%)	0.0%
Memory size	10.9 MiB

9a736b248f67d166d2fbb006bcb877c3	75
6fbc7cdadbb522125f4b27ae9dee4060	38
f9ae226291893fda10af7965268fb7f6	35
8af7ac63b2efbcbd88e5b11505e8098a	29
569aa12b73b5f7edeaa6f2a01603e381	26
Other values (95414)	118112

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3786080
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81018 ?
Unique (%)	68.5%

Sample

1st row	871766c5855e863f6eccc05f988b23cb
2nd row	0fb8e3eab2d3e79d92bb3fffbb97f188
3rd row	3419052c8c6b45daf79c1e426f9e9bcb
4th row	e7c828d22c0682c1565252deefbe334d
5th row	0bb98ba72dcc08e95f9d8cc434e9a2cc

Common Values

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
Other values (95409)	117992	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
Other values (95409)	117992	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	237656	6.3%
b	237239	6.3%
1	237104	6.3%
a	236995	6.3%
d	236943	6.3%
8	236741	6.3%
3	236718	6.3%
e	236647	6.3%
5	236552	6.2%
2	236547	6.2%
Other values (6)	1416938	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2365944	62.5%
Lowercase Letter	1420136	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	237656	10.0%
1	237104	10.0%
8	236741	10.0%
3	236718	10.0%
5	236552	10.0%
2	236547	10.0%
9	236461	10.0%
7	236364	10.0%
0	236193	10.0%
4	235608	10.0%

Lowercase Letter

Value	Count	Frequency (%)
b	237239	16.7%
a	236995	16.7%
d	236943	16.7%
e	236647	16.7%
f	236430	16.6%
c	235882	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2365944	62.5%
Latin	1420136	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	237656	10.0%
1	237104	10.0%
8	236741	10.0%
3	236718	10.0%
5	236552	10.0%
2	236547	10.0%
9	236461	10.0%
7	236364	10.0%
0	236193	10.0%
4	235608	10.0%

Latin

Value	Count	Frequency (%)
b	237239	16.7%
a	236995	16.7%
d	236943	16.7%
e	236647	16.7%
f	236430	16.6%
c	235882	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3786080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	237656	6.3%
b	237239	6.3%
1	237104	6.3%
a	236995	6.3%
d	236943	6.3%
8	236741	6.3%
3	236718	6.3%
e	236647	6.3%
5	236552	6.2%
2	236547	6.2%
Other values (6)	1416938	37.4%

customer_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	14976
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35051.68158

Minimum	1003
Maximum	99990
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1003
5-th percentile	3277.7
Q1	11310
median	24310
Q3	58640
95-th percentile	90582
Maximum	99990
Range	98987
Interquartile range (IQR)	47330

Descriptive statistics

Standard deviation	29824.81122
Coefficient of variation (CV)	0.8508810385
Kurtosis	-0.7823870696
Mean	35051.68158
Median Absolute Deviation (MAD)	16300
Skewness	0.7845220785
Sum	4147139706
Variance	889519364.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	161	0.1%
22790	155	0.1%
22793	154	0.1%
24230	141	0.1%
22775	128	0.1%
35162	125	0.1%
29101	119	0.1%
11740	110	0.1%
13087	108	0.1%
36570	105	0.1%
Other values (14966)	117009	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	4	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	2	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99990	1	< 0.1%
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%

customer_city
Categorical

HIGH CARDINALITY

Distinct	4110
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

sao paulo	18728
rio de janeiro	8261
belo horizonte	3274
brasilia	2484
curitiba	1816
Other values (4105)	83752

Length

Max length	32
Median length	9
Mean length	10.33405739
Min length	3

Characters and Unicode

Total characters	1222674
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1033 ?
Unique (%)	0.9%

Sample

1st row	campos dos goytacazes
2nd row	jatai
3rd row	belo horizonte
4th row	sao jose dos pinhais
5th row	conselheiro lafaiete

Common Values

Value	Count	Frequency (%)
sao paulo	18728	15.8%
rio de janeiro	8261	7.0%
belo horizonte	3274	2.8%
brasilia	2484	2.1%
curitiba	1816	1.5%
campinas	1743	1.5%
porto alegre	1667	1.4%
salvador	1537	1.3%
guarulhos	1404	1.2%
sao bernardo do campo	1121	0.9%
Other values (4100)	76280	64.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	25233	12.2%
paulo	18809	9.1%
de	11584	5.6%
rio	9906	4.8%
janeiro	8261	4.0%
do	5067	2.4%
belo	3348	1.6%
horizonte	3302	1.6%
brasilia	2494	1.2%
porto	1984	1.0%
Other values (3280)	117509	56.6%

Most occurring characters

Value	Count	Frequency (%)
a	201636	16.5%
o	150915	12.3%
i	93525	7.6%
r	90617	7.4%
	89182	7.3%
e	79407	6.5%
s	74861	6.1%
n	54198	4.4%
u	53650	4.4%
l	53296	4.4%
Other values (21)	281387	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1132940	92.7%
Space Separator	89182	7.3%
Dash Punctuation	288	< 0.1%
Other Punctuation	262	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	201636	17.8%
o	150915	13.3%
i	93525	8.3%
r	90617	8.0%
e	79407	7.0%
s	74861	6.6%
n	54198	4.8%
u	53650	4.7%
l	53296	4.7%
p	44441	3.9%
Other values (16)	236394	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Space Separator

Value	Count	Frequency (%)
	89182	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	262	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	288	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1132940	92.7%
Common	89734	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	201636	17.8%
o	150915	13.3%
i	93525	8.3%
r	90617	8.0%
e	79407	7.0%
s	74861	6.6%
n	54198	4.8%
u	53650	4.7%
l	53296	4.7%
p	44441	3.9%
Other values (16)	236394	20.9%

Common

Value	Count	Frequency (%)
	89182	99.4%
-	288	0.3%
'	262	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1222674	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	201636	16.5%
o	150915	12.3%
i	93525	7.6%
r	90617	7.4%
	89182	7.3%
e	79407	6.5%
s	74861	6.1%
n	54198	4.4%
u	53650	4.4%
l	53296	4.4%
Other values (21)	281387	23.0%

customer_state
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

SP	49865
RJ	15425
MG	13718
RS	6539
PR	5988
Other values (22)	26780

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236630
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RJ
2nd row	GO
3rd row	MG
4th row	PR
5th row	MG

Common Values

Value	Count	Frequency (%)
SP	49865	42.1%
RJ	15425	13.0%
MG	13718	11.6%
RS	6539	5.5%
PR	5988	5.1%
SC	4319	3.7%
BA	4069	3.4%
DF	2500	2.1%
GO	2453	2.1%
ES	2351	2.0%
Other values (17)	11088	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	49865	42.1%
rj	15425	13.0%
mg	13718	11.6%
rs	6539	5.5%
pr	5988	5.1%
sc	4319	3.7%
ba	4069	3.4%
df	2500	2.1%
go	2453	2.1%
es	2351	2.0%
Other values (17)	11088	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	64327	27.2%
P	60178	25.4%
R	28913	12.2%
M	16723	7.1%
G	16171	6.8%
J	15425	6.5%
A	6855	2.9%
E	6207	2.6%
C	5970	2.5%
B	4709	2.0%
Other values (7)	11152	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	236630	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	64327	27.2%
P	60178	25.4%
R	28913	12.2%
M	16723	7.1%
G	16171	6.8%
J	15425	6.5%
A	6855	2.9%
E	6207	2.6%
C	5970	2.5%
B	4709	2.0%
Other values (7)	11152	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	236630	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64327	27.2%
P	60178	25.4%
R	28913	12.2%
M	16723	7.1%
G	16171	6.8%
J	15425	6.5%
A	6855	2.9%
E	6207	2.6%
C	5970	2.5%
B	4709	2.0%
Other values (7)	11152	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	236630	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64327	27.2%
P	60178	25.4%
R	28913	12.2%
M	16723	7.1%
G	16171	6.8%
J	15425	6.5%
A	6855	2.9%
E	6207	2.6%
C	5970	2.5%
B	4709	2.0%
Other values (7)	11152	4.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	order_id	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	payment_sequential	payment_type	payment_installments	payment_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	seller_zip_code_prefix	seller_city	seller_state	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state
0	00010242fe8c5a6d1ba2dd792cb16214	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-09-19 09:45:35	58.9	13.29	1	credit_card	2	72.19	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	97ca439bc427b48bc1cd7177abe71365	5	NaN	Perfeito, produto entregue antes do combinado.	2017-09-21 00:00:00	2017-09-22 10:57:03	3ce436f183e68e07877b285a838db11a	delivered	2017-09-13 08:59:02	2017-09-13 09:45:35	2017-09-19 18:34:16	2017-09-20 23:43:48	2017-09-29 00:00:00	871766c5855e863f6eccc05f988b23cb	28013	campos dos goytacazes	RJ
1	130898c0987d1801452a8ed92a670612	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-07-05 02:44:11	55.9	17.96	1	boleto	1	73.86	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	b11cba360bbe71410c291b764753d37f	5	NaN	lannister como sempre, entregou certinho e dentro do prazo. recomendo muito	2017-07-14 00:00:00	2017-07-17 12:50:07	e6eecc5a77de221464d1c4eaff0a9b64	delivered	2017-06-28 11:52:20	2017-06-29 02:44:11	2017-07-05 12:00:33	2017-07-13 20:39:29	2017-07-26 00:00:00	0fb8e3eab2d3e79d92bb3fffbb97f188	75800	jatai	GO
2	532ed5e14e24ae1f0d735b91524b98b9	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2018-05-23 10:56:25	64.9	18.33	1	credit_card	2	83.23	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	af01c4017c5ab46df6cc810e069e654a	4	super recomendo	carrinho muito bonito	2018-06-05 00:00:00	2018-06-06 21:41:12	4ef55bf80f711b372afebcb7c715344a	delivered	2018-05-18 10:25:53	2018-05-18 12:31:43	2018-05-23 14:05:00	2018-06-04 18:34:26	2018-06-07 00:00:00	3419052c8c6b45daf79c1e426f9e9bcb	30720	belo horizonte	MG
3	6f8c31653edb8c83e1a739408b5ff750	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-08-07 18:55:08	58.9	16.17	1	credit_card	3	75.07	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	8304ff37d8b16b57086fa283fe0c44f8	5	NaN	NaN	2017-08-10 00:00:00	2017-08-13 03:35:17	30407a72ad8b3f4df4d15369126b20c9	delivered	2017-08-01 18:38:42	2017-08-01 18:55:08	2017-08-02 19:07:36	2017-08-09 21:26:33	2017-08-25 00:00:00	e7c828d22c0682c1565252deefbe334d	83070	sao jose dos pinhais	PR
4	7d19f4ef4d04461989632411b7e588b9	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-08-16 22:05:11	58.9	13.29	1	credit_card	4	72.19	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	426f43a82185969503fb3c86241a9535	5	NaN	NaN	2017-08-25 00:00:00	2017-08-28 00:51:18	91a792fef70ecd8cc69d3c7feb3d12da	delivered	2017-08-10 21:48:40	2017-08-10 22:05:11	2017-08-11 19:43:07	2017-08-24 20:04:21	2017-09-01 00:00:00	0bb98ba72dcc08e95f9d8cc434e9a2cc	36400	conselheiro lafaiete	MG
5	a0f9acf0b6294ed8561e32cde1a966bc	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-08-03 15:23:46	55.9	26.93	1	credit_card	1	82.83	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	c752337ac465a5e2fbdbedf7d79c6659	5	NaN	NaN	2017-08-27 00:00:00	2017-08-27 12:30:09	4851b3bca4a48b395dfad7aa57c3f72a	delivered	2017-07-27 15:11:51	2017-07-28 15:23:46	2017-08-02 18:32:34	2017-08-31 20:19:52	2017-08-24 00:00:00	33449409b16400dbeaf886a5140bf59c	44560	dom macedo costa	BA
6	bbf796534aaf9c59f8da8c7982db56e0	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2018-03-26 03:28:44	64.9	38.50	1	boleto	1	103.40	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	b41646a4365a1411101396c097413907	5	NaN	Muito bom chegou bem antes do prazo, produto de ótima qualidade meu filho amou	2018-03-29 00:00:00	2018-03-30 12:41:53	c32c207d9ebf75958011557ac1624e2f	delivered	2018-03-18 21:00:44	2018-03-20 03:28:44	2018-03-20 18:08:45	2018-03-28 21:57:44	2018-04-12 00:00:00	31b9765a88ef50ccd457bb40491c4fbf	45160	belo campo	BA
7	c9ef97d2854afe64a3b4488bc2836af6	2	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-08-14 04:25:34	58.9	18.12	1	boleto	1	153.75	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	dbacd3ac90ace7ad49fe8b31bbad2808	5	NaN	NaN	2017-08-15 00:00:00	2017-08-24 19:35:04	0a29abf475fb8039d2775913d6f0b6f0	delivered	2017-08-05 16:59:05	2017-08-08 04:25:34	2017-08-10 16:40:11	2017-08-14 18:13:03	2017-09-06 00:00:00	840f10bde3c94907105e032d9c2fec3b	75903	rio verde	GO
8	c9ef97d2854afe64a3b4488bc2836af6	1	436c8d57ff8d4aa254318e9bd9b48c83	48436dade18ac8b2bce089ec2a041202	2017-08-14 04:25:34	58.9	17.83	1	boleto	1	153.75	cool_stuff	54.0	599.0	6.0	530.0	30.0	9.0	14.0	27277	volta redonda	SP	dbacd3ac90ace7ad49fe8b31bbad2808	5	NaN	NaN	2017-08-15 00:00:00	2017-08-24 19:35:04	0a29abf475fb8039d2775913d6f0b6f0	delivered	2017-08-05 16:59:05	2017-08-08 04:25:34	2017-08-10 16:40:11	2017-08-14 18:13:03	2017-09-06 00:00:00	840f10bde3c94907105e032d9c2fec3b	75903	rio verde	GO
9	df2d910b8b5e5f461f67043489f9569d	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	2017-06-09 14:31:21	55.9	35.71	2	voucher	1	20.00	cool_stuff	58.0	598.0	4.0	650.0	28.0	9.0	14.0	27277	volta redonda	SP	4e58c72bb0373240b2bd9bf84b493a69	1	NaN	o carrinho veio com defeito.	2017-06-27 00:00:00	2017-06-30 14:26:54	2e76c1f2a920153d79cc98b634c50942	delivered	2017-06-05 12:22:19	2017-06-05 14:31:21	2017-06-07 13:09:07	2017-06-26 13:52:03	2017-07-06 00:00:00	0efd4833752113fedce2e7250d49d5ac	53403	paulista	PE

Last rows

	order_id	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	payment_sequential	payment_type	payment_installments	payment_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	seller_zip_code_prefix	seller_city	seller_state	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state
118305	fc8a4fcbc1b484046b9ff15de7c73577	1	86133a7d6682fcb51debce06e6514f93	101921376b577a4540dc30e9009133ca	2017-06-26 03:55:21	373.00	21.49	1	boleto	1	394.49	cool_stuff	52.0	394.0	1.0	5000.0	40.0	27.0	37.0	13505	rio claro	SP	aca2e1fcabddf4cdbfffc3e5c23abd2c	2	NaN	Faz mas de 25 dias uteis que fiz a compra.	2017-07-13 00:00:00	2017-07-13 11:25:52	48ce8cdeb8bb76e0593b9fcdce0b453e	processing	2017-05-19 16:14:42	2017-05-23 03:55:21	NaN	NaN	2017-07-07 00:00:00	6537286a5400c1e8bdf18907d66ff843	11680	ubatuba	SP
118306	fcb25cc2887d15b5373673a0630ad13a	1	47ac3d02c68a76bc97b3b305f6e1192f	749e7cdabbaf72f16677859e27874ba5	2017-09-08 17:30:19	41.90	19.84	1	credit_card	3	61.74	NaN	NaN	NaN	NaN	3100.0	18.0	45.0	30.0	7122	guarulhos	SP	4ca5b8211a47c58979fe315c25c2f649	1	NaN	NaN	2017-09-15 00:00:00	2017-09-16 00:57:55	3379c7a16d562a9dbdf4b6a3d55754b3	delivered	2017-09-03 17:20:56	2017-09-03 17:30:19	2017-09-05 20:40:00	2017-09-14 18:13:25	2017-09-21 00:00:00	3d7180d54d1d270196e1b6a82c50ef46	22775	rio de janeiro	RJ
118307	fd0342fda6ba083712b6ed0d4e6ac483	1	7683fe3e73bd7af6d0f6a6ed497cb04a	a1bea9970d8f65b240555f99c2214f7f	2018-07-27 17:20:37	75.00	27.48	1	credit_card	5	102.48	construcao_ferramentas_iluminacao	49.0	527.0	4.0	1450.0	60.0	5.0	30.0	83323	pinhais	PR	466e4bb0496ab856c8ec1753cfc87986	3	NaN	NaN	2018-08-02 00:00:00	2018-08-03 09:48:59	1d3e643209846ffadac771cc5dc1ed4b	delivered	2018-07-23 16:24:27	2018-07-23 17:21:07	2018-07-24 15:28:00	2018-08-01 23:46:21	2018-08-14 00:00:00	4f0a93edbe276308a671448764c8e1c2	79320	corumba	MS
118308	fd607d0a02cb276bc764a15f80f0423f	1	02ad78835ec3f72e750d1dfa6a7e11b3	2a73cba571d90c694b7caca072ccf6ce	2018-08-02 02:24:15	171.39	19.35	1	boleto	1	381.48	moveis_decoracao	38.0	1303.0	2.0	1250.0	52.0	7.0	11.0	9560	sao caetano do sul	SP	bb6e8f1301a860d4f8f42c1170608ead	5	NaN	NaN	2018-08-17 00:00:00	2018-08-19 23:37:17	fef79774a4f4ef014078bcb0b42d0cc5	delivered	2018-07-26 09:13:04	2018-07-27 02:24:15	2018-08-07 09:28:00	2018-08-16 17:12:37	2018-08-16 00:00:00	c13401002a5f9b60befb4c720de50be0	41820	salvador	BA
118309	fd607d0a02cb276bc764a15f80f0423f	2	02ad78835ec3f72e750d1dfa6a7e11b3	2a73cba571d90c694b7caca072ccf6ce	2018-08-02 02:24:15	171.39	19.35	1	boleto	1	381.48	moveis_decoracao	38.0	1303.0	2.0	1250.0	52.0	7.0	11.0	9560	sao caetano do sul	SP	bb6e8f1301a860d4f8f42c1170608ead	5	NaN	NaN	2018-08-17 00:00:00	2018-08-19 23:37:17	fef79774a4f4ef014078bcb0b42d0cc5	delivered	2018-07-26 09:13:04	2018-07-27 02:24:15	2018-08-07 09:28:00	2018-08-16 17:12:37	2018-08-16 00:00:00	c13401002a5f9b60befb4c720de50be0	41820	salvador	BA
118310	fdaf98feac227eb978d8f33f36e0231d	1	f739e9151702508b18f796c53005e5e9	d1aa1ec0839dcab73a6161130eb1f94a	2017-04-27 05:10:28	119.90	16.14	1	boleto	1	136.04	moveis_decoracao	44.0	533.0	2.0	1000.0	69.0	11.0	11.0	80220	curitiba	PR	fd48db39884359395ff6f18c8822aa7b	4	NaN	NaN	2017-05-25 00:00:00	2017-05-26 11:42:36	81ae83ce1a10af9f93fa3512bd9713b1	delivered	2017-04-19 10:20:51	2017-04-21 05:10:28	2017-05-04 15:06:24	2017-05-24 10:52:43	2017-05-22 00:00:00	3d50a44231c2a153219cef76ee3e445d	22793	rio de janeiro	RJ
118311	fe68b52db13993f58175fa589125d345	1	f4135cbdece8245560f7be179533797a	3fefda3299e6dfaea3466ef346a3571a	2017-08-17 02:55:27	209.00	16.21	1	boleto	1	225.21	eletronicos	32.0	1306.0	3.0	500.0	17.0	9.0	25.0	82620	curitiba	PR	cd6f089e896732c91671704c7f51790e	4	NaN	NaN	2017-08-18 00:00:00	2017-08-19 13:16:38	94203a446c1b46b5ac95b0aaf7221804	delivered	2017-08-11 10:15:22	2017-08-12 02:55:27	2017-08-14 22:03:19	2017-08-17 17:47:55	2017-09-04 00:00:00	52a953541861bbb4b79b39df24e00243	13485	limeira	SP
118312	fefacc66af859508bf1a7934eab1e97f	1	69c590f7ffc7bf8db97190b6cb6ed62e	80ceebb4ee9b31afb6c6a916a574a1e2	2018-08-02 04:05:13	6729.00	193.21	1	boleto	1	6922.21	pcs	50.0	1935.0	4.0	5660.0	54.0	18.0	47.0	86026	londrina	PR	ac0c6f54ff4bfc295468eb14f31c927f	1	Demora no retorno	Demora no retorno sobre o endereço de entrega	2018-08-16 00:00:00	2018-08-16 14:20:01	f48d464a0baaea338cb25f816991ab1f	delivered	2018-07-25 18:10:17	2018-07-27 04:05:13	2018-08-03 14:42:00	2018-08-15 14:57:50	2018-08-10 00:00:00	459bef486812aa25204be022145caa62	29066	vitoria	ES
118313	ff701a7c869ad21de22a6994237c8a00	1	5ff4076c0f01eeba4f728c9e3fa2653c	3e35a8bb43569389d3cebef0ce820f69	2018-04-18 20:10:33	27.90	14.44	1	credit_card	1	84.68	bebidas	28.0	242.0	1.0	2000.0	19.0	38.0	19.0	3124	sao paulo	SP	2926f21f2f2aba2ce11d801e17eac783	5	NaN	NaN	2018-04-21 00:00:00	2018-04-24 14:13:18	8f6d16c31abb30b7b4650272cb0014a3	delivered	2018-04-12 19:47:40	2018-04-12 20:10:33	2018-04-18 00:41:29	2018-04-20 17:48:39	2018-04-30 00:00:00	ddb2249e0316d365ceae561c0f011bce	12280	cacapava	SP
118314	ff701a7c869ad21de22a6994237c8a00	2	5ff4076c0f01eeba4f728c9e3fa2653c	3e35a8bb43569389d3cebef0ce820f69	2018-04-18 20:10:33	27.90	14.44	1	credit_card	1	84.68	bebidas	28.0	242.0	1.0	2000.0	19.0	38.0	19.0	3124	sao paulo	SP	2926f21f2f2aba2ce11d801e17eac783	5	NaN	NaN	2018-04-21 00:00:00	2018-04-24 14:13:18	8f6d16c31abb30b7b4650272cb0014a3	delivered	2018-04-12 19:47:40	2018-04-12 20:10:33	2018-04-18 00:41:29	2018-04-20 17:48:39	2018-04-30 00:00:00	ddb2249e0316d365ceae561c0f011bce	12280	cacapava	SP

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter